Telegram Group & Telegram Channel
ВПР ва ГПР каби машҳур функциялар бизга фақат биринчи натижани қайтаради, лекин Сизга охирги натижа керак бўлсачи?

ПРОСМОТР
нинг фойдали томони шундаки, Сиз айнан ушбу функция ёрдамида охирги натижани топишингиз мумкин.

Расмда ишлатилган функциялар:

Биринчи натижа учун: =ВПР(A1;A1:B10;2;0)
Охирги натижа учун: =ПРОСМОТР(A1;A1:A10;B1:B10)

🎯 P.S. Ҳали илғор фойдаланувчи бўлишга улгурмаган обуначиларимизга Excel Hacks видеокурсини ҳозироқ ўрганишни тавсия қиламан. Маълумот учун 👉🏻 @excel_videokursi_bot



tg-me.com/excel_hacks/419
Create:
Last Update:

ВПР ва ГПР каби машҳур функциялар бизга фақат биринчи натижани қайтаради, лекин Сизга охирги натижа керак бўлсачи?

ПРОСМОТР
нинг фойдали томони шундаки, Сиз айнан ушбу функция ёрдамида охирги натижани топишингиз мумкин.

Расмда ишлатилган функциялар:

Биринчи натижа учун: =ВПР(A1;A1:B10;2;0)
Охирги натижа учун: =ПРОСМОТР(A1;A1:A10;B1:B10)

🎯 P.S. Ҳали илғор фойдаланувчи бўлишга улгурмаган обуначиларимизга Excel Hacks видеокурсини ҳозироқ ўрганишни тавсия қиламан. Маълумот учун 👉🏻 @excel_videokursi_bot

BY Excel Hacks




Share with your friend now:
tg-me.com/excel_hacks/419

View MORE
Open in Telegram


Excel Hacks Telegram | DID YOU KNOW?

Date: |

If riding a bucking bronco is your idea of fun, you’re going to love what the stock market has in store. Consider this past week’s ride a preview.The week’s action didn’t look like much, if you didn’t know better. The Dow Jones Industrial Average rose 213.12 points or 0.6%, while the S&P 500 advanced 0.5%, and the Nasdaq Composite ended little changed.

Among the actives, Ascendas REIT sank 0.64 percent, while CapitaLand Integrated Commercial Trust plummeted 1.42 percent, City Developments plunged 1.12 percent, Dairy Farm International tumbled 0.86 percent, DBS Group skidded 0.68 percent, Genting Singapore retreated 0.67 percent, Hongkong Land climbed 1.30 percent, Mapletree Commercial Trust lost 0.47 percent, Mapletree Logistics Trust tanked 0.95 percent, Oversea-Chinese Banking Corporation dropped 0.61 percent, SATS rose 0.24 percent, SembCorp Industries shed 0.54 percent, Singapore Airlines surrendered 0.79 percent, Singapore Exchange slid 0.30 percent, Singapore Press Holdings declined 1.03 percent, Singapore Technologies Engineering dipped 0.26 percent, SingTel advanced 0.81 percent, United Overseas Bank fell 0.39 percent, Wilmar International eased 0.24 percent, Yangzijiang Shipbuilding jumped 1.42 percent and Keppel Corp, Thai Beverage, CapitaLand and Comfort DelGro were unchanged.

Excel Hacks from pl


Telegram Excel Hacks
FROM USA